// SPDX-FileCopyrightText: 2023-2025 Sangfor Technologies Inc.
// SPDX-License-Identifier: Mulan PSL v2
package com.geniusai.aip.auth.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.geniusai.aip.auth.domain.Pvcs;
import org.apache.ibatis.annotations.Select;

/**
 * @Entity com.geniusai.aip.auth.domain.Pvcs
 */
public interface PvcsMapper extends BaseMapper<Pvcs> {

    @Select("select ifnull(sum(size),0) from aip.pvcs where user_id = #{userId} group by user_id")
    Integer sumUserPvcSize(String userId);
}